package com.lyq.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lyq.pojo.Order;
import com.lyq.pojo.VO.OrderVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author lyq
 * @since 2020-05-29
 */
public interface OrderMapper extends BaseMapper<Order> {
        @Select("select o.* ,d.doctor_name,h.name,de.de_zh_name from orders o,doctor d,department de,hospital h where o.hid=h.id and o.did =de.id and o.order_do_id= d.doctor_id;")
            List<OrderVO> selectOrderAll();
}
